Inloggen / Registreren 141

Zoeken: Let It Snow

Hier vindt u de producten die voldoen aan uw zoekcriteria: Let It Snow.

Wilt u uw zoekopdracht verder specifieren? Geef dan aan naar welk type, afmetingen en kleuren u zoekt bij de pagina uitgebreid zoeken.


Zoekresultaten

De volgende fouten zijn opgetreden tijdens het zoeken:

  • Zoekwoord te kort: It

Er zijn geen producten gevonden die voldoen aan uw zoekcriteria.

Meld je aan voor onze nieuwsbrief

Copyright © 2008 - 2025 Art Concept International B.V. | All rights reserved | Algemene voorwaarden | Privacy policy

  Query Rows Time
1 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/webshop/cart/add/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
2 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/favorites/add/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
3 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/framing/start/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
4 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
5 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_formats/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
6 SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken/Let It Snow/479' AND `language` = '1' 1 0 ms
7 SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken/Let It Snow/479/' AND `language` = '1' 1 0 ms
8 SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken/Let It Snow/479' AND `language` = '1' 1 0 ms
9 SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken/Let It Snow/479/' AND `language` = '1' 1 0 ms
10 SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken/Let It Snow' AND `language` = '1' 1 0.01 ms
11 SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken/Let It Snow/' AND `language` = '1' 1 0 ms
12 SELECT COUNT(*) AS `Route.Findcount` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken' AND `language` = '1' 1 0.01 ms
13 SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
14 SELECT `id` as `Configuration.Id`, `value` as `Configuration.Value` FROM `configurations` AS `Configuration` 15 0 ms
15 DELETE FROM `discount_codes` WHERE `valid_till` < 1765536373 0 0 ms
16 SELECT `reference` as `ProductLimitedEdition.Reference`, `circulation` as `ProductLimitedEdition.Circulation` FROM `product_limited_editions` AS `ProductLimitedEdition` 208 0.01 ms
17 SELECT `id` as `Translation.Id`, `value` as `Translation.Value` FROM `translations` AS `Translation` WHERE `language` = '1' 32 0.14 ms
18 SELECT `product` FROM `product_tags` LEFT JOIN `product_by_tags` ON `product_tags`.`id` = `product_by_tags`.`tag` WHERE `name` = 'let' 26 0.01 ms
19 SELECT `id` FROM `products` WHERE `title` LIKE '%let%' 2075 1.78 ms
20 SELECT `id` FROM `products` WHERE `artist_first` LIKE '%let%' OR `artist_last` LIKE '%let%' 2497 3.2 ms
21 SELECT `products_in_categories`.`product` FROM `products_in_categories` LEFT JOIN `product_categories` ON `products_in_categories`.`category` = `product_categories`.`id` WHERE `product_categories`.`category_name` LIKE '%let%' 0 0.01 ms
22 SELECT `id` FROM `products` WHERE `id` = 'Let' 0 0 ms
23 SELECT `product` FROM `product_tags` LEFT JOIN `product_by_tags` ON `product_tags`.`id` = `product_by_tags`.`tag` WHERE `name` = 'snow' 0 0 ms
24 SELECT `id` FROM `products` WHERE `title` LIKE '%snow%' 1437 2.31 ms
25 SELECT `id` FROM `products` WHERE `artist_first` LIKE '%snow%' OR `artist_last` LIKE '%snow%' 2 3.64 ms
26 SELECT `products_in_categories`.`product` FROM `products_in_categories` LEFT JOIN `product_categories` ON `products_in_categories`.`category` = `product_categories`.`id` WHERE `product_categories`.`category_name` LIKE '%snow%' 0 0.01 ms
27 SELECT `id` FROM `products` WHERE `id` = 'Snow' 0 0 ms
28 SELECT `id` as `Product.Id`, `id` as `Product.Id` FROM `products` AS `Product` WHERE `Product`.`id` IN(0,380136,380137,448801,459324,459232,458929,458637,458590,457743,419309,459723,448370,448303,447997,427086,414019,410935,459558,459883,459798,408554,468288,472456,478433,478506,481281,489027,533969,533968,503597,503601,504817,504827,508416,410496,399226,402556,309014,449957,21305,21369,21370,309483,400961,423331,424203,403671,276866,291836,306199,306943,308001,309403,308651,309467,309932,329149,329228,329265,341081,341093,357325,398799,398802,399144,399150,399155,399224,539347,448307,341560,477791,478069,477792,519050,539509,502779,309383,489109,475493,475494,478067,477795,475495,477796,475496,477794,403960,503573,403961,341563,477797,509279,477790,327881,472468,450140,410681,478068,448203,448207,507904,341561,447967,323653,489072,405888,327882,458638,405889,399145,427085,478066,477793,323657,417028,417011,462272,461621,461570,417793,417579,417010,417202,417091,474512,474513,474515,474514,474516,474517,474511,474505,474510,474509,474508,474519,474504,474507,474506,474518,474477,474520,475239,475293,475292,474502,475284,475240,473100,475238,474521,475237,474649,474648,474524,474523,474522,474503,474482,473101,474475,475326,474478,474476,474479,474480,474481,474483,474484,474485,474486,474487,474488,474489,474490,474491,473102,473105,473103,474501,474500,473104,474499,474498,474497,474492,474496,474495,473106,473662,474494,474493,475321,477830,475366,477826,477832,477831,473098,477829,477828,477827,477825,477834,477824,477823,477822,477821,477820,477819,477818,477833,477835,477816,478117,478140,478139,478138,478121,478120,478119,478118,478116,477836,477843,477842,477841,477840,477839,477838,477837,477817,477815,475367,477684,477695,477691,477688,477687,477686,477685,477683,477698,477680,477679,477678,477677,477676,477675,475525,477697,477701,477814,477806,477813,477812,477811,477810,477809,477808,477807,477805,477782,477804,477803,477802,477801,477800,477799,477798,473099,454300,473097,449247,449864,449863,449553,449552,449551,449550,449055,449866,449054,446780,446779,446227,446020,446019,446018,449865,449867,446016,449998,453241,451364,451363,451362,450268,450000,449999,449997,449868,449996,449995,449899,449898,449871,449870,449869,446017,446015,453243,445984,445991,445990,445989,445988,445987,445986,445985,445911,445993,445791,444253,443891,443513,443001,443000,442999,445992,445994,446014,446004,446013,446012,446011,446009,446008,446006,446005,446003,445995,446002,446001,446000,445999,445998,445997,445996,453242,453244,468320,467688,467755,467754,467692,467691,467690,467689,467687,467757,467686,467347,467346,467339,467338,466976,466975,467756,467760,465917,467907,468319,468318,468118,467911,467910,467909,467908,467906,467761,467905,467904,467903,467902,467901,467900,467899,465918,464963,453245,453254,454296,454295,454294,453258,453257,453256,453255,453253,454298,453252,453251,453250,453249,453248,453247,453246,454297,454299,464962,457420,464961,464960,464927,457836,457835,457809,457808,457419,478142,457403,457402,454305,454304,454303,454302,454301,478141,478165,478143,504349,504358,504357,504356,504355,504354,504353,504352,504351,504350,504348,504360,504347,504346,504345,504344,504343,504342,504341,504340,504339,504338,504359,504361,504336,504374,504384,504383,504382,504381,504380,504379,504378,504377,504376,504375,504373,504362,504372,504371,504370,504369,504368,504367,504366,504365,504364,504363,504337,504335,504386,501666,503013,502986,502985,502954,502953,502952,502951,502344,501667,501665,503015,501664,501663,501662,501661,501660,501659,501658,501657,501656,501655,503014,503016,504334,504323,504333,504332,504331,504330,504329,504328,504327,504326,504325,504324,504322,503018,504321,504320,504319,504318,504317,504316,504315,504314,504313,504312,504385,504387,501267,511251,483440,511319,511318,511317,511316,511315,511254,511253,511252,511250,511335,511249,511236,510815,510814,510813,510812,510777,510576,510575,510551,511334,511336,510549,511412,511422,511421,511420,511419,511418,511417,511416,511415,511414,511413,511411,511337,511410,511409,511408,511407,511406,511405,511404,511403,511339,511338,510550,510548,504388,504400,504410,504409,504408,504407,504406,504405,504404,504403,504402,504401,504399,504412,504398,504397,504396,504395,504394,504393,504392,504391,504390,504389,504411,504413,510492,504426,510462,510457,510398,504433,504432,504431,504430,504429,504428,504427,504425,504414,504424,504423,504422,504421,504420,504419,504418,504417,504416,504415,501654,501266,478144,484074,486190,484344,484343,484342,484341,484247,484246,484140,484087,484005,487055,484004,484003,484002,484001,484000,483999,483998,483997,483996,483995,486191,487056,483993,494661,494724,494723,494722,494721,494720,494719,494665,494664,494663,494662,494658,487444,494657,494656,492690,492689,492688,492063,492062,492056,492055,488194,483994,483992,494726,482183,483719,483718,483717,483716,482781,482780,482647,482646,482185,482076,483796,478345,442823,478164,478163,478162,478161,478160,478147,478146,478145,483795,483797,483991,483980,483990,483989,483988,483987,483986,483985,483984,483983,483982,483981,483979,483798,483978,483977,483976,483975,483974,483972,483807,483806,483805,483804,494725,495291,501265,500828,500837,500836,500835,500834,500833,500832,500831,500830,500829,500827,500839,500826,500825,500824,500823,500822,500821,500820,500819,500711,500710,500838,500840,500708,501005,501264,501263,501262,501261,501260,501259,501258,501254,501253,501006,501004,500841,500851,500850,500849,500848,500847,500846,500845,500844,500843,500842,500709,500707,495292,495576,495586,495585,495584,495583,495582,495581,495580,495579,495578,495577,495575,495588,495574,495573,495572,495571,495570,495569,495519,495469,495468,495355,495587,495589,500706,500695,500705,500704,500703,500702,500701,500700,500699,500698,500697,500696,500694,495590,500693,500692,500691,500690,500689,500688,498316,495593,495592,495591,442998,403781,442555,403639,403647,403646,403645,403644,403643,403642,403641,403640,403638,403649,403637,403636,403635,403634,403633,403632,403631,403630,403648,403650,403628,403662,403670,403669,403668,403667,403666,403665,403664,403663,403661,403651,403660,403659,403658,403657,403656,403655,403654,403653,403652,403629,403627,403673,383238,399736,399735,395317,395316,383420,383419,383418,383417,383237,399738,383236,383235,383234,383233,381079,381078,381077,380402,399737,402440,403626,403617,403625,403624,403623,403622,403621,403620,403619,403618,403616,402441,402450,402449,402448,402447,402446,402445,402444,402443,402442,403672,403674,380397,403731,403739,403738,403737,403736,403735,403734,403733,403732,403730,403741,403729,403728,403727,403726,403725,403724,403723,403722,403740,403742,403720,403754,403762,403761,403760,403759,403758,403757,403756,403755,403753,403743,403752,403751,403750,403749,403748,403747,403746,403745,403744,403721,403719,403675,403686,403694,403693,403692,403691,403690,403689,403688,403687,403685,403696,403684,403683,403682,403681,403680,403679,403678,403677,403676,403695,403697,403718,403709,403717,403716,403715,403714,403713,403712,403711,403710,403708,403698,403707,403706,403705,403704,403703,403702,403701,403700,403699,380401,380395,403764,306918,316377,313534,313533,312682,308810,308789,308788,308787,306917,316385,306916,306915,306914,306913,306912,306911,306910,306909,316378,316386,306907,325723,325777,325776,325775,325774,325727,325726,325725,325724,325722,316387,325721,321623,316394,316393,316392,316391,316390,316389,316388,306908,306906,325779,303172,303629,303628,303627,303626,303625,303624,303174,303173,303171,303631,302427,302426,302420,302419,302246,302245,302130,302129,302047,303630,303632,306905,305577,306904,306903,305593,305592,305581,305580,305579,305578,305576,303666,305463,305462,304437,304436,304435,304108,304107,304025,304024,325778,325780,380392,350365,353675,350482,350481,350379,350377,350376,350367,350366,350364,353677,350363,349118,349066,348928,348508,348507,348023,348022,353676,353678,348020,378285,380387,378754,378753,378752,378751,378750,378749,378748,378284,353734,378283,378282,376429,375502,375501,375500,375499,375309,353735,348021,348019,325781,325973,327928,327927,327926,327925,326234,326233,325975,325974,325972,328698,325971,325970,325969,325968,325967,325785,325784,325783,325782,327982,328699,347711,338472,347461,347212,346603,341810,341809,341808,341807,338473,338309,328700,338308,335990,329675,329674,329673,329672,329124,329123,328701,403763,403765,442544,412968,412976,412975,412974,412973,412972,412971,412970,412969,412967,412978,412966,412019,412018,412017,407439,407438,407321,407320,412977,412979,407318,415536,416672,416671,416670,416669,416668,416667,415538,415537,415535,412980,415512,415511,415510,415509,415353,415352,415345,415344,412981,407319,407317,416674,403959,405052,405051,403967,403966,403965,403964,403963,403962,403958,405280,403957,403956,403955,403954,403953,403952,403951,403950,405279,405281,407316,406606,407315,407314,406612,406611,406610,406609,406608,406607,406605,405282,406500,406479,405445,405444,405287,405286,405285,405284,405283,416673,417101,403948,431957,432225,432224,432223,432153,432152,431960,431959,431958,431954,432561,431953,431327,431326,431325,431324,431323,431322,429193,432226,432562,429191,433710,442436,442191,433928,433927,433926,433925,433924,433923,433709,432563,433097,433089,432569,511512,432568,432567,432566,432565,432564,429192,429190,420392,420990,421920,421722,421709,421708,421707,421706,421705,421704,420989,421922,420988,420987,420986,420985,420984,420983,420982,420981,420393,421921,421923,428409,427850,428408,428407,428406,428405,428404,428018,428017,428016,427849,422026,427848,427847,427846,427845,424835,422660,422659,422658,422657,403949,403947,403766,403823,403831,403830,403829,403828,403827,403826,403825,403824,403822,403833,403821,403820,403819,403818,403817,403816,403815,403814,403832,403834,403812,403846,403854,403853,403852,403851,403850,403849,403848,403847,403845,403835,403844,403843,403842,403841,403840,403839,403838,403837,403836,403813,403811,403856,403777,403786,403785,403784,403783,403782,403780,403779,403778,403776,403788,403775,403774,403773,403772,403771,403770,403769,403768,403767,403787,403789,403810,403801,403809,403808,403807,403806,403805,403804,403803,403802,403800,403790,403799,403798,403797,403796,403795,403794,403793,403792,403791,403855,403857,403946,403914,403922,403921,403920,403919,403918,403917,403916,403915,403913,403924,403912,403911,403910,403909,403908,403907,403906,403905,403923,403925,403903,403937,403945,403944,403943,403942,403941,403940,403939,403938,403936,403926,403935,403934,403933,403932,403931,403930,403929,403928,403927,403904,403902,403858,403869,403877,403876,403875,403874,403873,403872,403871,403870,403868,403879,403867,403866,403865,403864,403863,403862,403861,403860,403859,403878,403880,403901,403892,403900,403899,403898,403897,403896,403895,403894,403893,403891,403881,403890,403889,403888,403887,403886,403885,403884,403883,403882,511459,533955,511513,466073,440086,466079,466078,466077,466076,466080,466075,466074,466072,492872,435981,435980,438171,488756,488757,488758,439157,439075,460504,492873,488755,270535,542238,542237,328875,328874,328873,328872,265524,440538,436282,519288,270534,503560,503559,445249,222220,96422,51625,461167,483028,438768,488753,503484,437077,438498,438497,437459,440362,440321,437087,440333,437078,489992,436733,483844,467045,467044,467047,467046,523725,440361,439928,436732,263132,488754,311308,488751,488752,541258,517914,488759,325041,311310,311309,410469,263133,540633,399171,543259,455489,467493,379150,398999,281422,436735,352225,313989,472474,410501,410503,410500,410502,410499,409162,409161,479309,478439,410498,478467,282165,89655,282164,89654,451023,333765,283138,89653,498131,539502,543264,276058,398414,342082,329135,308121,306081,281228,276860,276094,347743,489417,438369,448618,281441,539505,438366,327863,327862,539504,539503,542228,542227,349357,377427,443402,439556,436107,439701,265529,265528,433350,433349,347793,459254,344320,284229,90834,515567,419790,487218,487217,487216,487215,329309,339911,543265,503973,543689,436683,261418,287387,287386,25458,543693,421553,483918,307513,437563,516056,306094,306082,329266,542542,398718,221819,505496,399139,458628,410901,517896,436791,437184,459695,329969,329968,329963,329962,419301,522136,436793,481278,504768,503554,504867,419395,439536,539451,329961,436794,436795,488707,396846,399132,336442,307235,289102,281227,485084,485083,458917,396845,436796,396844,396843,380386,380384,380383,380385,416919,380382,436720,329960,488708,504830,294261,440164,439456,439455,311298,311299,438191,436972,436971,441528,439729,439619,223114,97316,539447,444778,404597,399194,539767,439439,439337,517868,439078,429043,442416,515922,444783,437080,364132,440278,439964,438318,539449,439817,439389,458967,309916,543452,439690,539516,539514,323937,478970,541989,519499,294265,340762,275406,275155,309511,536488,294344,294266,294347,489110,275044,486688,378576,486687,378575,345059,499694,499693,499692,340763,275154,499690,518804,464612,429733,429732,327571,503586,503575,503567,503566,503565,275153,518803,503557,458613,504083,349988,439124,275445,275045,275167,499691,499689,317152,413500,446289,356436,501322,509292,339677,413503,413502,413501,458629,380140,481269,423715,423716,423717,503558,346333,442548,380141,317151,265527,380142,499688,474401,499687,499686,504882,489080,341539,341163,503562,474402,497920,503568,446377,446325,446339,468195,465187,465186,432011,543194,518802,399164,410922,308120,442469,376509,352833,517838,443522,536339,443389,443521,442480,314274,406515,442570,348656,346158,514803,264830,264829,481282,309922,347038,308105,459910,439947,348571,272985,436836,509244,439521,439520,438881,439963,439106,400456,439027,440283,440041,439259,439945,438978,438977,436027,321917,460440,357327,264984,439667,458225,502713,346332,402409,410875,519226,439338,439828,439668,529536,350613,468825,459688,451966,448692,404668,350677,404145,542543,529537,509234,526136,443864,425836,436958,437096,352226,439777,439899,528949,525284,441693,522478,521986,437568,445250,513265,513264,285118,232299,329229,503045,264985,434590,514857,329964,309382,309482,442052,435399,437764,437626,514855,514856,329966,462380,442078,533833,350347,439794,468471,329957,329956,329965,329967,525393,522095,301270,434756,522345,522081,522080,522228,522227,522096,522094,436721,522146,528455,524272,509288,410631,541694,541695,541762,541761,461200,525564,473608,520481,525629,527989,526471,522546,529524,528434,524156,525704,527729,526744,522457,347030,505477,308104,528853,436564,346666,441411,446426,521100,526745,524698,446449,517764,525868,525072,525288,524928,543197,518627,442734,446416,526746,446427,446423,446369,446417,468762,524165,524300,526748,526747,434591,463843,478482,308199,308282,308200,539671,504775,478484,426148,323651,308281,503577,324163,509287,503584,456560,509298,504820,504819,478505,431873,323650,426147,309548,308098,458932,329262,329261,399230,308747,341558,309015,505287,539674,478485,323655,462323,503582,503581,539673,426146,323654,539672,504776,309549,481288,398993,459912,458922,458965,323901,503569,503563,503576,481289,404451,323900,458925,458933,329311,509284,431872,431871,431870,504832,503580,503553,458928,459724,281339,447118,309547,405891,405890,458918,519279,503572,503578,309545,458935,309546,503579,447119,504813,503561,503564,503570,458924,458923,329263,398994,417706,406575,351102,517521,435823,380020,464387,438303,375694,289650,265172,313969,265171,539507,519195,432582,432006,432005,431996,318083,543098,543187,258312,541841,461127,539506,427304,360128,312699,463835,328388,350664,395110,422405,350716,483169,346578,422411,422410,422409,422408,422407,422406,543186,258311,518809,306214,308099,308106,518805,323647,410925,459725,503574,431874,426500,323938,426501,426502,426503,309587,399231,399229,508363,434758,399225,518808,518807,425839,431875,437625,437624,347502,488180,475458,475457,475456,475455,456558,380843,329264,428123,503583,271343,281421,308720,380846,380844,380845,539751,307968,511514,527615,528043,528042,528041,527593,527750,527398,522036,519777,527694,528045,527411,527410,527409,527677,520596,527754,528569,521223,528044,528046,527616,521369,529031,529147,521373,521056,521464,521463,521288,521488,336108,528047,527650,527649,527648,527814,527813,527812,527811,528049,528048,527628,524755,529033,517774,439074,437421,436748,449953,449952,307432,307429,461202,516161,440088,456557,504810,468440,420317,329312,265162,265161,339910,439811,411654,527988,472497,527753,528092,527862,527861,506801,341762,321908,509294,399174,515878,339912,329176,309043,306211,329876,329875,329874,329873,458858,529032,523349,281495,503612,458920,461201,458927,402601,503504,458926,402597,309874,309875,294728,458655,468761,499344,399227,475302,475301,468117,475300,294722,504815,458630,483830,483822,483823,483820,483819,483821,483818,483831,483832,483829,483838,483827,483828,483826,483825,483824,510796,483834,483836,483835,475299,499333,521510,521409,520110,520146,520120,520171,521489,529387,529383,529382,521517,309586,523156,522844,521541,521414,521285,521830,521403,522921,521501,439647,410634,499323,339705,461199,268994,529285,443217,309888,459692,445352,279924,469994,504766,469993,405893,405892,341470,341468,380698,504811,461651,459690,306198,480484,483833,516561,533967,533966,533965,533957,533956,302045,533954,516562,516560,533971,516559,516558,516557,514691,514471,513648,513647,513646,533970,533972,513258,540301,541217,541216,540307,540306,540305,540304,540303,540302,540300,533983,540299,540298,540297,540296,540295,534001,534000,533985,533984,513259,513257,541234,511560,511615,511614,511613,511612,511610,511563,511562,511561,511559,511617,511558,511557,511556,511555,511518,511517,511516,511515,511616,511618,512016,511630,512015,512014,511766,511765,511764,511763,511742,511741,511629,511619,511628,511627,511626,511625,511624,511623,511622,511621,511620,541233,541235,517918,439109,437424,437457,529041,529198,523860,323936,457474,437630,443038,440354,440281,439985,438657,436861,521974,522229,521142,522545,437425,539266,522411,246693,420315,440313,518426,528667,527982,329825,246695,246694,435359,439697,529036,514278,440298,439110,500510,439767,439559,439558,439210,522041,521624,541236,544562,544570,544569,544568,544567,544566,544565,544564,544563,544561,544572,544560,544559,544558,544557,544556,542081,542080,541238,541237,544571,544573,522144,492289,522145,522143,313589,536397,455149,444736,466596,466595,492288,544574,492287,519513,503505,427238,399002,545076,545075,544671,544670,483837,528475,410675,308117,488311,489984,438653,440171,431878,520081,489804,516451,341597,458934,350516,329308,520803,307243,472459,472458,439725,489000,399228,504812,517771,519932,525479,439753,472470,472469,439960,439951,352253,400924,519937,504814,519989,300491,398889,539766,539749,518812,309318,410886,509285,488988,438929,523842,436895,518811,447989,308723,417169,436606,436755,437063,437062,528762,539765,519763,519785,519816,519818,519780,519787,519786,454199,539748,512782,503585,435461,443390,439772,493310,350147,459694,309705,346151,348371,439905,512783,503571,503556,539768,539750,308119,508677,459564,512785,512784,447377,523846,522701,529020,376653,331571,527881,527880,450696,528985,529022,529021,529019,528359,528882,528881,528880,528879,528878,528877,528876,528875,520917,528347,528945,448841,504764,497805,416350,416345,416344,528852,528721,489111,485557,483234,485556,485555,321932,459691,503555,528404,528263,528174,528403,528955,437621,523834,521781,521045,524429,524826,523776,522518,522517,522516,523568,521632,523914,521631,523790,522022,522021,522019,523890,523913,524792,524791,524503,524576,440349,523686,459565,410685,521187,522547,522247,521870,522476,519768,523737,521617,523812,521640,521615,521639,523736,524441,521682,523760,523975,398998,504045,520999,436765,436553,436562,436554,438913,438905,438925,439873,437223,445235,437044,347841,285913,350047,399193,412394,412393,400925,435118,434745,435362,288112,300715,325559,309307,509025,539450,396789,459911,515568,308118,300714,441412,300713,300712,300711,300710,329313,352250,438123,436598,441413,435115,398997,428315,527671,437665,521120,521241,521076,521075,519871,525309,525534,523563,308006,521151,521243,26266,521138,521102,521147,522524,521032,528279,271148,504809,519194,410906,507944,507597,398442,377120,339854,306942,96119,221917,518908,308007,458931,458930,483034,343797,533764,410633,444752,459696,543690,375956,454193,341553,468441,439803,352243,458559,458558,458557,458560,399192,489160,439793,356435,223105,431869,439633,439632,439829,439712,439620,265177,439698,447953,438979,456559,424836,444755,437041,437047,437045,437042,437046,437043,472579,410885,472574,539448,539446,410905,410884,404671,401071,399195,399111,436594,436593,457883,521805,528699,519753,523819,523980,523840,523977,524007,522847,522554,484789,523771,523732,523731,523946,410632,441639,517705,1806,1805,523151,484790,446378,441294,459693,529533,396834,396833,396832,396831,436674,436662,442352,30967,517931,446425,404587,399140,351930,424493,282290,30968,282289,302046,511320,302044,507093,412469,412468,311637,507005,410659,319319,319306,473707,543251,412471,507092,344278,507054,507044,497007,461562,423311,496074,412470,532992,375714,419328,419330,490693,490692,490691,490690,419329,502286,502285,419327,381890,479374,479373,479372,430298,479371,430297,429928,281356,503434,480471,306415,479755,423364,463410,311287,285312,505265,519478,479523,532416,424236,423357,507427,424229,543499,532666,507449,506694,498357,496401,496283,497074,448129,502224,457832,363509,543599,336339,430320,415457,415456,365658,365657,410376,543500,431179,535700,535699,535698,535697,506973,459568,459384,425275,479754,479756,411208,423180,318889,318888,416277,318887,416276,318886,396180,281680,411665,318891,452173,452172,460663,457684,508734,508708,543347,539852,318890,292128,503977,506429,467980,282581,467979,282580,297256,461606,480644,326242,506428,292430,506427,506426,496725,508680,341227,396315,396314,292400,292345,504031,503940,479757,507064,511221,511226,511220,518777,516320,280098,532148,497229,456251,511222,380231,429867,429785,419057,497054,401783,341440,479037,511227,511223,480669,339704,466811,459364,458583,457655,447145,411242,356535,342075,465716,511224,407913,407912,506054,480643,541248,541247,456726,456725,511225,490089,519284,283035,463716,451099,453868,543451,483403,402527,375648,306185,460076,336588,451101,336584,402537,375649,419163,404461,396013,345328,456902,451100,399446,406756,285125,257923,259462,259461,259460,259459,256707,258348,258347,226755,505083,397356,543354,322050,340064,488271,410693,459474,414111,307722,426569,336238,26025,491444,529717,428728,402494,357241,484513,484512,505233,356713,345311,418342,321816,409864,542917,514928,279815,279814,365323,532074,322463,489105,426789,309062,336224,448429,382045,307430,539771,518715,497828,410466,410691,532443,451105,398849,278218,489263,459583,450924,450022,306064,381511,424182,46758,463848,64745,506164,489291,489286,468573,456848,424172,423223,281141,430266,543344,430265,430264,281288,506064,261925,326039,449677,449676,504204,399888,497105,468558,466126,466125,466124,466123,466122,466121,496242,479670,466807,468210,536197,460974,280992,395954,312853,279755,479821,375730,305946,449678,334205,225365,380472,345777,448662,336526,336521,508379,410690,319336,327698,380471,378697,496191,466823,327102,420475,505410,287612,287611,225364,281012,417620,334204,307688,424233,423361,466810,410038,410039,410041,410040,396163,281647,427365,506178,504003,281602,281139,308917,497394,307052,508381,508380,467981,293514,441488,335283,378071,378070,378069,378068,378067,505987,505988,335282,334076,269553,334075,513221,513220,534448,534447,257935,429485,429484,378072,465745,429482,445022,46379,44976,343354,257516,68365,44975,282253,7237,537825,284060,537826,363460,349516,426266,445961,284063,284062,284061,266736,429483,413476,68366,309659,426506,430146,517988,526545,437520,345355,489003,309668,309665,434320,532254,489775,488991,309444,309440,524222,524226,524303,518353,434321,413475,341754,413474,413473,413472,413471,404435,341753,341752,341755,328858,528372,328857,328856,328855,406106,526584,427469,380325,526484,519865,46380,257517,524187,414620,544917,544916,544915,544914,544913,544912,438421,438465,383399,31692,438255,473256,25361,260396,281383,25946,25945,281380,544464,544877,343825,258444,275448,443099,363496,302043,343341,257505,68346,37177,258443,54746,258442,544179,544178,32021,343574,258368,257666,68167,66775,343826,257987,343355,257519,345061,441386,6936,461338,434776,509815,343359,343358,68121,408927,67169,44993,343357,343356,257518,68120,67168,44992,504638,482946,441856,466768,513739,518020,445688,445609,411531,498237,498243,282838,335862,338883,335861,335860,335859,335858,335857,465503,465502,462646,462645,524103,544872,260294,259634,306971,352767,323978,489838,308307,445470,51318,259635,517792,297107,273008,259152,315124,315123,364955,506349,506348,506580,483650,350678,506578,467662,222213,96415,474912,474910,396949,295091,295090,505269,307565,350614,406744,406743,364735,359160,98054,47109,544071,94680,275450,506579,506577,40338,481444,293829,293824,293830,293825,356384,319148,319147,481445,41947,432107,41946,283546,260297,290808,260296,291297,260295,291298,410221,424634,284441,417550,90981,284440,90980,424777,424776,543016,300191,300190,396166,424635,316025,316030,282646,6695,283168,6694,405403,405404,479428,40116,40789,544871,284090,496204,496203,506702,279376,353277,516673,516660,284091,338091,518873,285964,364883,288225,462093,522805,522945,523271,523270,496205,532207,522740,53162,544870,544869,258170,299486,299485,516883,529130,529129,307362,308485,497063,524332,524174,524241,524240,524295,524294,532668,532616,523287,246479,445888,376115,277678,444377,519954,526562,526291,298424,298423,495432,489769,309071,488329,462296,448331,402811,402810,269600,269599,98816,280643,345368,246478,443145,246477,525690,281568,519568,349480,327550,327549,444062,346076,377119,517485,353185,353209,444887,488327,509297,482844,466765,377322,532061,532032,18685,52911,347153,347152,69615,536101,433866,433865,461336,225376,308232,501870,452520,452519,452518,452517,535932,432921,53842,481917,501869,503911,432919,523700,544756,316622,94771,94603,31936,272501,286828,347103,523554,437644,376557,27044,445863,445867,94756,543850,395089,542284,310030,432920,481916,325478,26809,527567,1717,314287,467737,341764,348473,1931,26810,516761,527882,350043,436478,436445,380477,273727,440757,439787,439506,527717,528070,432918,402802,382655,432917,481915,335544,351861,474808,474806,487702,349828,316616,285999,259072,525896,525895,312705,313763,312458,16325,312456,313456,325479,506888,485835,319394,319390,319386,436271,518350,484848,484847,485836,497602,420330,301366,301365,400921,400920,293669,261669,294066,293668,518127,275444,437200,326270,544706,222450,96652,52141,31866,383400,455670,41347,463366,439738,539634,507523,396006,261449,268087,268086,542152,475009,475007,444917,437199,542183,446029,479355,480091,479356,480090,479354,402473,427626,483347,445890,288184,346388,436328,436327,436329,349883,52796,355857,355856,466406,414598,437198,488354,437197,437196,522431,528746,528745,523937,523969,521759,488353,497532,276947,276683,276681,276680,276230,490564,423876,263770,263769,461609,396414,495450,279793,453700,520706,522648,523047,448971,448970,448965,339841,279792,446604,310922,467307,467306,346619,461337,444349,445889,498040,453701,443313,526018,523196,350055,481070,481069,399328,523076,522976,523608,522988,523187,450065,523091,523086,522846,420372,427651,415317,352180,223270,97472,347908,526016,40442,346894,26755,26754,473308,516069,442711,445337,295619,297132,98078,438541,97567,442113,347127,535974,313140,22591,458484,483284,441174,438543,526015,436142,526014,526013,526012,526011,528626,441387,327376,436143,438551,438548,438545,438561,441175,438542,440557,438535,438552,438544,438592,39843,40933,396413,542153,516264,318734,325011,65894,448493,444912,435741,281382,275446,423146,448492,344777,414210,414209,502534,266293,435503,267553,423145,423147,402649,461342,545000,44911,44883,544999,44910,44882,266220,492805,428932,423148,416374,364926,305209,475327,221738,95940,485521,485520,310115,322669,464997,52541,406497,304597,305204,304598,305202,304596,91009,313480,540428,461964,316664,461962,313977,396441,533671,455344,322814,267465,225531,305203,354508,464996,316835,497906,540860,303815,540859,303814,381864,309605,231860,348159,354509,273151,323205,306474,306473,66226,306472,66225,265559,265558,461153,523976,481300,518371,421090,273578,273577,292850,260066,326948,266315,543745,222709,510188,96911,544115,544114,94656,313484,518493,518492,268277,421091,510189,268282,90671,429773,429780,396731,349406,518372,490598,428970,282586,490597,510190,428969,282585,90670,396481,396480,282624,89819,282372,89818,269073,431467,463272,544261,32142,31567,52576,544157,31888,31321,16440,16364,94697,32143,43615,292509,260521,294754,288606,223146,97348,402283,31568,544410,431466,444075,431465,431464,514669,379126,276200,544169,514707,478692,410767,544411,324536,313478,276202,273427,268250,266966,261311,313121,40936,456101,311651,448330,307155,281894,281893,309693,419850,336428,334716,319976,316882,3234,507179,327100,409735,327101,421459,421461,421146,365165,336573,503679,375706,507941,468755,489803,479157,410787,518980,468252,448059,448054,426768,24048,543089,375660,406876,488900,495378,509168,376038,341944,340486,396034,329165,421460,426356,459537,323821,279455,279311,277653,424213,423341,302373,488959,447865,359839,308300,399514,400569,427300,399533,324492,419484,311650,324589,457035,345753,336287,421462,460087,430323,425426,425110,421145,377561,345752,329166,339805,402483,503915,468176,489906,419932,419019,408652,497437,381185,458754,502339,523922,467923,89272,89271,529611,293721,447082,467926,467925,467924,467922,283161,467921,467920,467916,400714,400713,317741,434774,536153,283822,491512,434773,544710,267633,267632,323958,351569,544712,31865,544711,31864,31863,491513,544709,31869,544708,31868,52145,543857,94872,491515,491514,537582,325791,379190,487477,487485,487489,487484,487483,487482,487481,487480,487478,487476,487487,487475,487479,487474,487473,487472,487471,499363,499250,487486,487488,310372,262506,327366,468948,503885,500210,488196,410765,262508,262507,262505,487490,262504,262503,506860,487496,487495,487494,487493,487492,487491,379189,326949,491821,526985,97179,405359,405358,405357,405356,417990,283078,89815,379378,488579,414424,420313,435598,263235,263234,263233,536187,445887,222977,488578,436151,520224,448754,409887,313827,469178,517617,443495,346319,520491,520229,488577,522780,379322,409832,284105,522868,347586,328985,328984,409620,318162,411552,350584,441220,438620,438619,439034,437562,437566,437569,478987,437623,536630,438396,351975,396164,375515,375514,396416,518489,396415,441299,349932,438395,438397,520763,261725,520764,1108,445364,98131,97854,456240,459581,495415,333458,438398,98937,98936,98935,98940,98939,467277,306479,300745,437567,348178,544878,257774,264470,264478,264477,264476,264475,264474,264473,264472,264471,264469,264480,264468,264467,264466,264465,264464,264463,264462,264461,264479,264481,264459,264493,267011,267010,264499,264498,264497,264496,264495,264494,264492,264482,264491,264490,264489,264488,264487,264486,264485,264484,264483,264460,264458,267919,262279,264433,264432,264431,264430,264429,264428,262383,262280,262278,264435,262277,262248,262247,261659,261658,261624,261623,261517,264434,264436,264457,264448,264456,264455,264454,264453,264452,264451,264450,264449,264447,264437,264446,264445,264444,264443,264442,264441,264440,264439,264438,267918,268829,261408,268885,268893,268892,268891,268890,268889,268888,268887,268886,268884,268895,268883,268882,268881,268880,268879,268878,268877,268876,268894,268896,268874,268908,268916,268915,268914,268913,268912,268911,268910,268909,268907,268897,268906,268905,268904,268903,268902,268901,268900,268899,268898,268875,268873,268830,268840,268848,268847,268846,268845,268844,268843,268842,268841,268839,268850,268838,268837,268836,268835,268834,268833,268832,268831,268849,268851,268872,268863,268871,268870,268869,268868,268867,268866,268865,268864,268862,268852,268861,268860,268859,268858,268857,268856,268855,268854,268853,261493,261407,268918,90859,90883,90882,90881,90880,90863,90862,90861,90860,90858,90891,90716,90715,90714,90713,90712,90711,90692,90688,90890,90892,90652,96437,98697,98696,98015,97963,97962,97860,97807,97523,95013,90893,94973,90913,90912,90911,90910,90901,90900,90899,90898,90653,90630,222235,90342,90427,90411,90410,90388,90387,90345,90344,90343,90325,90441,90324,90276,90275,90274,355992,90251,90250,90249,90428,90442,90622,90591,90621,90620,90619,90617,90614,90613,90595,90594,90590,90455,90589,90562,90561,90556,90555,90554,90553,90531,90530,98699,222958,261402,260015,260131,260130,260129,260056,260055,260018,260017,260016,259973,260148,259972,259966,259965,259820,259819,259818,259817,259770,260132,260149,259760,260629,261084,261083,260951,260950,260910,260874,260631,260630,260628,260150,260617,260616,260615,260614,260234,260233,260232,260231,260151,259761,259740,222959,256645,258913,258912,258911,258910,258152,258151,256647,256646,256526,259131,256525,256518,256517,245725,245724,245719,245718,223321,259130,259132,259739,259654,259722,259721,259705,259704,259701,259657,259656,259655,259653,259133,259652,259651,259650,259431,259430,259429,259428,259135,259134,268917,268919,90231,284315,284343,284342,284337,284336,284331,284330,284327,284326,284314,284345,284313,284312,284239,284238,284237,284128,284127,284059,284344,284354,284057,286255,286264,286263,286262,286261,286259,286258,286257,286256,286254,284355,286252,286251,286250,284369,284368,284365,284364,284357,284356,284058,284056,290097,282596,283306,283304,283302,283301,283280,283279,283235,283100,282595,283308,282591,282508,282470,282321,282266,282137,282129,282128,283307,283657,284055,283972,284054,284033,284032,284001,284000,283976,283975,283974,283949,283658,283864,283863,283862,283859,283798,283793,283706,283691,283690,286265,291139,282089,295055,300925,300629,300628,299948,299947,299946,298307,295598,295054,300966,294951,294950,294822,294821,294820,294819,294818,294817,300926,300967,294786,301687,302042,301750,301749,301692,301691,301690,301689,301688,301686,300968,301685,301684,301357,301356,301353,301352,300971,300970,300969,294787,294780,292196,293416,294061,294050,294049,294017,294016,293591,293590,293589,292640,294154,292618,292608,292607,292558,292455,292454,292354,292281,294153,294178,294779,294351,294778,294777,294461,294407,294406,294405,294360,294359,294350,294183,294349,294348,294289,294260,294239,294238,294237,294236,294213,282090,282088,268920,270362,270370,270369,270368,270367,270366,270365,270364,270363,270361,270372,270360,270359,270358,270357,270356,270355,270354,270353,270371,270373,269744,270385,270393,270392,270391,270390,270389,270388,270387,270386,270384,270374,270383,270382,270381,270380,270379,270378,270377,270376,270375,269745,269743,270395,268930,268938,268937,268936,268935,268934,268933,268932,268931,268929,268940,268928,268927,268926,268925,268924,268923,268922,268921,268939,268941,269742,268953,269741,269740,269739,269738,269737,269736,269735,269734,268952,268942,268951,268950,268949,268948,268947,268946,268945,268944,268943,270394,270396,282081,270452,270460,270459,270458,270457,270456,270455,270454,270453,270451,270462,270450,270449,270448,270447,270446,270445,270444,270443,270461,270463,270441,270475,282080,282059,282058,282034,281992,270478,270477,270476,270474,270464,270473,270472,270471,270470,270469,270468,270467,270466,270465,270442,270440,270397,270407,270415,270414,270413,270412,270411,270410,270409,270408,270406,270417,270405,270404,270403,270402,270401,270400,270399,270398,270416,270418,270439,270430,270438,270437,270436,270435,270434,270433,270432,270431,270429,270419,270428,270427,270426,270425,270424,270423,270422,270421,270420,90248,90273,90230,16169,18895,506053,416268,441415,444081,406511,460472,460471,16136,341040,445329,420547,347012,420400,346119,445543,445542,350303,279536,459984,233927,258160,321929,352062,351012,314320,364930,265567,265566,343941,497565,342088,275190,275191,275426,514160,267520,267519,267518,267517,443186,349874,536505,528603,380371,361284,442009,347218,460464,69593,442216,346193,417355,380366,3332,348179,346015,523973,348765,534518,534517,421565,406746,361285,53220,460428,518497,422773,445412,441963,417188,380368,380367,380370,69408,353320,98761,304387,349677,518495,445281,442328,347661,347399,313708,223336,528599,496861,376563,466038,470445,506587,290432,289916,479918,477564,445423,466039,466037,417788,466036,510496,485523,485522,325401,539894,531259,517680,470446,407611,466944,428675,42437,333298,47404,90209,42470,42448,42436,327335,478601,424283,478680,478600,506285,275443,275442,513124,513123,513122,513121,334894,466945,478599,469920,42369,282292,42368,441651,474189,474188,485840,485839,469919,522587,485651,485650,474187,474186,486322,470003,486321,470002,282293,524196,483310,257213,364807,446330,421539,421540,414525,414760,225520,342932,67010,524197,4789,409844,447362,447361,445421,349203,417303,414732,522188,406745,376400,42471,149,437583,333013,51219,914,150,333012,51218,913,333675,440948,912,148,333011,51217,911,147,458142,395124,440251,440951,320332,509183,536253,46845,509184,421560,288347,271585,271584,333713,304714,438962,439052,439133,440949,438161,440950,440252,439134,440986,438732,500213,320331,298637,22848,475687,475686,475685,323206,462699,266203,27238,474195,424861,352326,466157,466156,353958,353957,475048,355994,355993,475047,475688,438866,509181,3260,447648,295559,295558,264800,353202,98381,3292,3289,314691,441205,447415,413783,469500,295211,338672,338671,338670,338669,418679,298636,428481,462111,532605,41326,41217,479919,314664,259159,314663,259158,532606,544046,23720,544794,32041,31756,361320,318270,25503,25502,292520,542507,352221,513290,535527,346522,445166,486643,290448,260265,486642,290449,260264,407683,55903,535526,407682,464190,5847,284514,55905,284513,55904,284512,513291,519530,509182,467069,539575,532535,532534,261740,261739,346088,467068,467067,467070,515928,467071,467072,467073,459899,380425,438387,492701,492700,442425,306205,463731,363497,463730,474361,304888,304576,304887,532706,448246,430659,383125,448499,383124,461340,480290,454489,536587,433417,433416,433415,433414,42449,42482,42483,31253,31287,31273,31272,31269,31268,31256,31255,31254,31252,31293,31251,31246,31245,31243,26514,26513,26512,26511,31288,31294,26502,31830,39985,39984,39983,39775,37251,31993,31859,31831,31734,31295,31733,31732,31708,31707,31572,31571,31302,31301,31296,26503,26501,40605,21301,21339,21338,21325,21324,21314,21304,21303,21302,15517,21366,15515,14962,4482,4480,47405,3957,3956,2168,21365,21367,26500,23909,26499,26439,26438,26427,26426,26363,26362,25596,23908,21368,23907,23906,23778,23776,22979,22977,22943,21376,21375,40367,40606,2140,53186,65838,64600,64599,64598,64560,64559,55036,53187,53185,69550,52512,52511,52099,52098,52017,52016,52015,51821,69549,69551,51803,90141,90208,90185,90184,90181,90180,90153,90152,90142,90140,69553,90139,90119,90118,90069,90068,90020,90019,89982,69555,51804,46907,40607,41964,44151,41992,41991,41990,41989,41983,41982,41969,41166,45528,41139,41138,41137,41136,41087,41086,41085,40832,45526,46286,46906,46352,46522,46521,46520,46519,46370,46369,46364,46363,46351,46291,46350,46349,46342,46341,46322,46321,46314,46313,46292,2162,3967,2139,468366,376792,533527,291704,479096,479095,496430,468368,468367,468365,376794,468364,496747,479494,496746,479493,479942,479941,479940,376793,265449,439394,294735,266219,258730,502062,2049,474891,474890,540206,348290,461689,265450,437756,437541,440315,438470,438469,438468,438508,265452,265451,479482,437543,266218,306053,466131,505945,466524,466523,480612,469954,469953,493199,436571,495886,436570,504725,504724,333304,47410,42488,42454,333299,466132,285169,438403,466262,380546,480613,458033,290490,503289,503288,285447,496160,488426,325480,488425,461688,416888,496483,325488,325485,325484,325483,380326,258485,502061,300778,499683,1227,544088,94744,544087,94743,464144,499685,499684,499682,1307,499681,499680,499679,499678,499677,300779,486675,465316,465315,1228,1308,465317,1688,2048,2047,2046,1754,1753,1744,1743,1689,1616,1410,1614,1580,1563,1562,1492,1467,1427,1424,1423,465318,486676,442888,257284,376356,519289,41180,425656,542154,339194,339193,343035,67798,516059,5753,397223,438307,436106,435569,524714,543969,94997,282839,447606,270611,542797,517073,348908,335596,519926,308400,377007,377005,377008,377006,518309,348347,443103,443102,444903,442224,411638,363257,318305,349684,380084,282802,289974,289975,379542,380074,417449,380840,416965,416975,417295,462094,272363,261443) AND `Product`.`deleted` = 0 AND `Product`.`file_exists` = 1 AND `Product`.`tagged` = 1 5766 0.68 ms
29 SELECT `product_type_id` as `ProductType.Product_type_id`, `product_type` as `ProductType.Product_type` FROM `product_types` AS `ProductType` ORDER BY `menu_order` ASC 9 0.01 ms
30 SELECT `product_type_id` as `ProductType.Product_type_id`, `product_type` as `ProductType.Product_type` FROM `product_types` AS `ProductType` ORDER BY `menu_order` ASC 9 0 ms
31 SELECT `id` as `ProductOn.Id`, `value` as `ProductOn.Value` FROM `product_on` AS `ProductOn` 15 0.01 ms
32 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/search/simple' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
33 SELECT COUNT(*) AS `WebshopCart.Findcount` FROM `webshop_carts` AS `WebshopCart` WHERE `ip` = '216.73.216.215' 1 0.72 ms
34 DESCRIBE `webshop_carts` 14 0.01 ms
35 DESCRIBE `products` 33 0.07 ms
36 DESCRIBE `frame_static` 12 0.19 ms
37 DESCRIBE `lj_frame_static` 21 0.03 ms
38 DESCRIBE `frame_borders` 15 0.01 ms
39 DESCRIBE `frame_glasses` 9 0.01 ms
40 SELECT `WebshopCart`.`id` as `WebshopCart.Id`, `WebshopCart`.`ip` as `WebshopCart.Ip`, `WebshopCart`.`product` as `WebshopCart.Product`, `WebshopCart`.`quantity` as `WebshopCart.Quantity`, `WebshopCart`.`frame_border` as `WebshopCart.Frame_border`, `WebshopCart`.`static_frame` as `WebshopCart.Static_frame`, `WebshopCart`.`lj_static_frame` as `WebshopCart.Lj_static_frame`, `WebshopCart`.`passepartout` as `WebshopCart.Passepartout`, `WebshopCart`.`ppt_size` as `WebshopCart.Ppt_size`, `WebshopCart`.`cut` as `WebshopCart.Cut`, `WebshopCart`.`glass` as `WebshopCart.Glass`, `WebshopCart`.`extra` as `WebshopCart.Extra`, `WebshopCart`.`giftcard` as `WebshopCart.Giftcard`, `WebshopCart`.`last_update` as `WebshopCart.Last_update`, `Product`.`id` as `Product.Id`, `Product`.`vendor` as `Product.Vendor`, `Product`.`vendor_podexchange` as `Product.Vendor_podexchange`, `Product`.`reference` as `Product.Reference`, `Product`.`artist_first` as `Product.Artist_first`, `Product`.`artist_last` as `Product.Artist_last`, `Product`.`title` as `Product.Title`, `Product`.`description` as `Product.Description`, `Product`.`paper_width` as `Product.Paper_width`, `Product`.`paper_height` as `Product.Paper_height`, `Product`.`image_width` as `Product.Image_width`, `Product`.`image_height` as `Product.Image_height`, `Product`.`price` as `Product.Price`, `Product`.`discount` as `Product.Discount`, `Product`.`deleted` as `Product.Deleted`, `Product`.`tagged` as `Product.Tagged`, `Product`.`retag` as `Product.Retag`, `Product`.`product_type` as `Product.Product_type`, `Product`.`product_on` as `Product.Product_on`, `Product`.`file_exists` as `Product.File_exists`, `Product`.`allow_framing` as `Product.Allow_framing`, `Product`.`order` as `Product.Order`, `Product`.`placed` as `Product.Placed`, `Product`.`artline_pricecode` as `Product.Artline_pricecode`, `Product`.`pod` as `Product.Pod`, `Product`.`pod_allow_canvas` as `Product.Pod_allow_canvas`, `Product`.`pod_allow_dibond` as `Product.Pod_allow_dibond`, `Product`.`pod_allow_plexi` as `Product.Pod_allow_plexi`, `Product`.`pod_wh_ratio` as `Product.Pod_wh_ratio`, `Product`.`newimported` as `Product.Newimported`, `Product`.`randomfrontpage` as `Product.Randomfrontpage`, `Product`.`img` as `Product.Img`, `Product`.`thumb` as `Product.Thumb`, `FrameStatic`.`id` as `FrameStatic.Id`, `FrameStatic`.`vendor` as `FrameStatic.Vendor`, `FrameStatic`.`code` as `FrameStatic.Code`, `FrameStatic`.`material` as `FrameStatic.Material`, `FrameStatic`.`color` as `FrameStatic.Color`, `FrameStatic`.`profile_width_mm` as `FrameStatic.Profile_width_mm`, `FrameStatic`.`cost` as `FrameStatic.Cost`, `FrameStatic`.`height` as `FrameStatic.Height`, `FrameStatic`.`width` as `FrameStatic.Width`, `FrameStatic`.`framefile` as `FrameStatic.Framefile`, `FrameStatic`.`deleted` as `FrameStatic.Deleted`, `FrameStatic`.`order` as `FrameStatic.Order`, `LjFrameStatic`.`id` as `LjFrameStatic.Id`, `LjFrameStatic`.`code` as `LjFrameStatic.Code`, `LjFrameStatic`.`material` as `LjFrameStatic.Material`, `LjFrameStatic`.`color` as `LjFrameStatic.Color`, `LjFrameStatic`.`profile_width_mm` as `LjFrameStatic.Profile_width_mm`, `LjFrameStatic`.`cost` as `LjFrameStatic.Cost`, `LjFrameStatic`.`height` as `LjFrameStatic.Height`, `LjFrameStatic`.`width` as `LjFrameStatic.Width`, `LjFrameStatic`.`description` as `LjFrameStatic.Description`, `LjFrameStatic`.`framefile` as `LjFrameStatic.Framefile`, `LjFrameStatic`.`alt_desc` as `LjFrameStatic.Alt_desc`, `LjFrameStatic`.`google_feed_use` as `LjFrameStatic.Google_feed_use`, `LjFrameStatic`.`google_title` as `LjFrameStatic.Google_title`, `LjFrameStatic`.`google_description` as `LjFrameStatic.Google_description`, `LjFrameStatic`.`google_product_category` as `LjFrameStatic.Google_product_category`, `LjFrameStatic`.`google_site_category` as `LjFrameStatic.Google_site_category`, `LjFrameStatic`.`google_brand` as `LjFrameStatic.Google_brand`, `LjFrameStatic`.`google_gtin` as `LjFrameStatic.Google_gtin`, `LjFrameStatic`.`order` as `LjFrameStatic.Order`, `LjFrameStatic`.`visible` as `LjFrameStatic.Visible`, `LjFrameStatic`.`deleted` as `LjFrameStatic.Deleted`, `FrameBorder`.`id` as `FrameBorder.Id`, `FrameBorder`.`vendor` as `FrameBorder.Vendor`, `FrameBorder`.`code` as `FrameBorder.Code`, `FrameBorder`.`color` as `FrameBorder.Color`, `FrameBorder`.`material` as `FrameBorder.Material`, `FrameBorder`.`profile_width_mm` as `FrameBorder.Profile_width_mm`, `FrameBorder`.`max_width` as `FrameBorder.Max_width`, `FrameBorder`.`max_height` as `FrameBorder.Max_height`, `FrameBorder`.`cost_static` as `FrameBorder.Cost_static`, `FrameBorder`.`cost_m_under5cm` as `FrameBorder.Cost_m_under5cm`, `FrameBorder`.`cost_m_over5cm` as `FrameBorder.Cost_m_over5cm`, `FrameBorder`.`baklijst` as `FrameBorder.Baklijst`, `FrameBorder`.`tagged` as `FrameBorder.Tagged`, `FrameBorder`.`file_exists` as `FrameBorder.File_exists`, `FrameBorder`.`deleted` as `FrameBorder.Deleted`, `FrameGlass`.`id` as `FrameGlass.Id`, `FrameGlass`.`vendor` as `FrameGlass.Vendor`, `FrameGlass`.`code` as `FrameGlass.Code`, `FrameGlass`.`description` as `FrameGlass.Description`, `FrameGlass`.`cost_m2` as `FrameGlass.Cost_m2`, `FrameGlass`.`cost_static` as `FrameGlass.Cost_static`, `FrameGlass`.`max_length_cm` as `FrameGlass.Max_length_cm`, `FrameGlass`.`can_have_ppt` as `FrameGlass.Can_have_ppt`, `FrameGlass`.`laminate` as `FrameGlass.Laminate` FROM `webshop_carts` AS `WebshopCart` LEFT JOIN `products` AS `Product` ON `Product`.`id` = `WebshopCart`.`product` LEFT JOIN `frame_static` AS `FrameStatic` ON `FrameStatic`.`id` = `WebshopCart`.`static_frame` LEFT JOIN `lj_frame_static` AS `LjFrameStatic` ON `LjFrameStatic`.`id` = `WebshopCart`.`lj_static_frame` LEFT JOIN `frame_borders` AS `FrameBorder` ON `FrameBorder`.`id` = `WebshopCart`.`frame_border` LEFT JOIN `frame_glasses` AS `FrameGlass` ON `FrameGlass`.`id` = `WebshopCart`.`glass` WHERE `ip` = '216.73.216.215' 141 0.73 ms
41 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/search/advanced' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.09 ms
42 SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `route` = '/wanddecoratie-zoeken/Let%20It%20Snow/479' ORDER BY `route` DESC LIMIT 1 0 0.01 ms
43 DESCRIBE `routes` 4 0.05 ms
44 SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language`, `route_old` as `Route.Route_old` FROM `routes` AS `Route` WHERE `url` = '/search/simple/' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
45 SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language`, `route_old` as `Route.Route_old` FROM `routes` AS `Route` WHERE `url` = '/search/simple/' AND `language` = '3' ORDER BY `route` DESC LIMIT 1 1 0 ms
46 SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language`, `route_old` as `Route.Route_old` FROM `routes` AS `Route` WHERE `url` = '/search/simple/' AND `language` = '2' ORDER BY `route` DESC LIMIT 1 1 0 ms
47 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/user/login' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
48 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/user/register' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
49 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/webshop/cart' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
50 SELECT *, SUM(`id`) AS `discounted` FROM `products_in_categories` LEFT JOIN `products` ON `products`.`id` = `products_in_categories`.`product` WHERE `products`.`discount` > 0 GROUP BY `category` 200 1.11 ms
51 SELECT `product_type_id` as `ProductType.Product_type_id`, `product_type` as `ProductType.Product_type` FROM `product_types` AS `ProductType` WHERE `menu_order` >= 0 ORDER BY `menu_order` ASC 7 0 ms
52 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.03 ms
53 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
54 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
55 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/plexiglas' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
56 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
57 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
58 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/aluminium' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
59 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
60 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
61 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/1' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
62 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '0' 1 0 ms
63 DESCRIBE `product_categories` 4 0.01 ms
64 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '0' ORDER BY `category_name` ASC 32 0 ms
65 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '3' 1 0 ms
66 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/3' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
67 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '3' 1 0 ms
68 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/3' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
69 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '3' ORDER BY `category_name` ASC 6 0 ms
70 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '26' 1 0 ms
71 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/26' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
72 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '26' 1 0 ms
73 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '24' 1 0 ms
74 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/24' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
75 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '24' 1 0 ms
76 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '118' 1 0 ms
77 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/118' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
78 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '118' 1 0 ms
79 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '25' 1 0 ms
80 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/25' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
81 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '25' 1 0 ms
82 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '1' 1 0 ms
83 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/1' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
84 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '1' 1 0 ms
85 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '598' 1 0 ms
86 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/598' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
87 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '598' 1 0 ms
88 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '134' 1 0 ms
89 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/134' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
90 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '134' 1 0 ms
91 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '134' ORDER BY `category_name` ASC 3 0 ms
92 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '154' 1 0 ms
93 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/154' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
94 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '154' 1 0.01 ms
95 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '156' 1 0 ms
96 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/156' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
97 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '156' 1 0 ms
98 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '155' 1 0 ms
99 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/155' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
100 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '155' 1 0 ms
101 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '5' 1 0 ms
102 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/5' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
103 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '5' 1 0 ms
104 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '4' 1 0 ms
105 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/4' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
106 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '4' 1 0 ms
107 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/4' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
108 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '4' ORDER BY `category_name` ASC 4 0 ms
109 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '711' 1 0 ms
110 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/711' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
111 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '711' 1 0 ms
112 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '27' 1 0 ms
113 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/27' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
114 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '27' 1 0 ms
115 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '28' 1 0 ms
116 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/28' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
117 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '28' 1 0 ms
118 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '119' 1 0 ms
119 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/119' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
120 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '119' 1 0 ms
121 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '135' 1 0 ms
122 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/135' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
123 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '135' 1 0 ms
124 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/135' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
125 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '135' ORDER BY `category_name` ASC 2 0 ms
126 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '222' 1 0 ms
127 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/222' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
128 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '222' 1 0 ms
129 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '235' 1 0 ms
130 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/235' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
131 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '235' 1 0 ms
132 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '2' 1 0 ms
133 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/2' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
134 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '2' 1 0 ms
135 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/2' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
136 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '2' ORDER BY `category_name` ASC 15 0.01 ms
137 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '595' 1 0 ms
138 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/595' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
139 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '595' 1 0.01 ms
140 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '30' 1 0.01 ms
141 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/30' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
142 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '30' 1 0 ms
143 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '32' 1 0.01 ms
144 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/32' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
145 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '32' 1 0 ms
146 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '600' 1 0 ms
147 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/600' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
148 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '600' 1 0 ms
149 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '29' 1 0 ms
150 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/29' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
151 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '29' 1 0.01 ms
152 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '36' 1 0.01 ms
153 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/36' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
154 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '36' 1 0.01 ms
155 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '717' 1 0.01 ms
156 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/717' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
157 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '717' 1 0 ms
158 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '597' 1 0 ms
159 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/597' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
160 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '597' 1 0 ms
161 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '34' 1 0.01 ms
162 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/34' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
163 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '34' 1 0 ms
164 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '35' 1 0 ms
165 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/35' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
166 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '35' 1 0 ms
167 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '596' 1 0 ms
168 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/596' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
169 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '596' 1 0.01 ms
170 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '31' 1 0 ms
171 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/31' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
172 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '31' 1 0 ms
173 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '603' 1 0 ms
174 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/603' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
175 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '603' 1 0 ms
176 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '33' 1 0 ms
177 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/33' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
178 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '33' 1 0 ms
179 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '726' 1 0 ms
180 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/726' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
181 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '726' 1 0 ms
182 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '7' 1 0 ms
183 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/7' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
184 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '7' 1 0 ms
185 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/7' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
186 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '7' ORDER BY `category_name` ASC 3 0 ms
187 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '593' 1 0.01 ms
188 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/593' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.02 ms
189 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '593' 1 0 ms
190 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '592' 1 0 ms
191 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/592' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
192 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '592' 1 0 ms
193 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '594' 1 0 ms
194 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/594' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
195 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '594' 1 0 ms
196 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '138' 1 0 ms
197 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/138' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
198 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '138' 1 0 ms
199 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/138' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
200 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '138' ORDER BY `category_name` ASC 3 0 ms
201 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '244' 1 0 ms
202 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/244' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
203 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '244' 1 0 ms
204 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '160' 1 0 ms
205 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/160' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
206 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '160' 1 0.01 ms
207 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '161' 1 0 ms
208 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/161' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
209 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '161' 1 0 ms
210 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '6' 1 0 ms
211 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/6' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
212 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '6' 1 0 ms
213 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/6' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
214 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '6' ORDER BY `category_name` ASC 17 0 ms
215 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '43' 1 0 ms
216 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/43' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
217 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '43' 1 0 ms
218 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '253' 1 0.01 ms
219 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/253' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
220 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '253' 1 0 ms
221 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '234' 1 0 ms
222 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/234' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
223 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '234' 1 0 ms
224 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '262' 1 0 ms
225 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/262' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
226 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '262' 1 0.01 ms
227 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '609' 1 0 ms
228 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/609' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
229 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '609' 1 0 ms
230 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '40' 1 0.01 ms
231 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/40' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
232 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '40' 1 0 ms
233 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '38' 1 0 ms
234 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/38' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
235 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '38' 1 0 ms
236 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '41' 1 0 ms
237 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/41' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
238 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '41' 1 0 ms
239 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '44' 1 0 ms
240 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/44' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
241 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '44' 1 0 ms
242 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '39' 1 0 ms
243 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/39' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
244 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '39' 1 0 ms
245 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '263' 1 0 ms
246 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/263' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
247 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '263' 1 0 ms
248 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '37' 1 0 ms
249 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/37' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
250 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '37' 1 0 ms
251 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '629' 1 0 ms
252 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/629' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
253 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '629' 1 0 ms
254 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '610' 1 0 ms
255 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/610' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
256 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '610' 1 0 ms
257 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '42' 1 0 ms
258 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/42' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
259 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '42' 1 0 ms
260 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '257' 1 0 ms
261 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/257' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
262 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '257' 1 0 ms
263 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '712' 1 0 ms
264 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/712' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
265 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '712' 1 0 ms
266 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '139' 1 0 ms
267 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/139' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
268 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '139' 1 0 ms
269 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/139' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
270 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '139' ORDER BY `category_name` ASC 2 0 ms
271 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '308' 1 0 ms
272 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/308' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
273 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '308' 1 0 ms
274 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '247' 1 0 ms
275 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/247' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
276 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '247' 1 0 ms
277 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '8' 1 0 ms
278 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/8' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
279 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '8' 1 0 ms
280 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/8' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
281 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '8' ORDER BY `category_name` ASC 3 0 ms
282 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '49' 1 0 ms
283 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/49' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
284 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '49' 1 0 ms
285 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '51' 1 0.01 ms
286 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/51' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
287 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '51' 1 0 ms
288 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '50' 1 0 ms
289 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/50' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
290 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '50' 1 0 ms
291 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '9' 1 0 ms
292 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/9' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
293 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '9' 1 0 ms
294 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/9' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
295 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '9' ORDER BY `category_name` ASC 8 0 ms
296 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '54' 1 0 ms
297 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/54' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
298 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '54' 1 0 ms
299 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '57' 1 0 ms
300 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/57' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
301 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '57' 1 0 ms
302 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '140' 1 0 ms
303 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/140' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
304 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '140' 1 0 ms
305 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '55' 1 0 ms
306 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/55' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
307 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '55' 1 0 ms
308 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '727' 1 0 ms
309 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/727' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
310 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '727' 1 0 ms
311 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '56' 1 0 ms
312 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/56' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
313 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '56' 1 0 ms
314 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '53' 1 0 ms
315 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/53' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
316 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '53' 1 0 ms
317 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '599' 1 0.01 ms
318 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/599' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
319 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '599' 1 0 ms
320 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '10' 1 0 ms
321 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/10' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
322 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '10' 1 0.01 ms
323 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/10' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
324 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '10' ORDER BY `category_name` ASC 2 0 ms
325 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '59' 1 0 ms
326 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/59' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
327 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '59' 1 0 ms
328 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '58' 1 0.01 ms
329 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/58' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
330 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '58' 1 0 ms
331 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '141' 1 0 ms
332 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/141' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
333 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '141' 1 0 ms
334 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/141' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
335 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '141' ORDER BY `category_name` ASC 1 0 ms
336 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '718' 1 0.01 ms
337 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/718' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
338 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '718' 1 0 ms
339 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '11' 1 0 ms
340 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
341 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '11' 1 0 ms
342 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
343 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '11' ORDER BY `category_name` ASC 19 0.01 ms
344 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '239' 1 0 ms
345 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/239' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
346 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '239' 1 0 ms
347 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '63' 1 0 ms
348 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/63' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
349 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '63' 1 0 ms
350 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '255' 1 0.01 ms
351 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/255' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
352 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '255' 1 0.01 ms
353 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '265' 1 0.01 ms
354 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/265' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
355 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '265' 1 0 ms
356 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '314' 1 0 ms
357 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/314' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
358 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '314' 1 0 ms
359 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '719' 1 0 ms
360 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/719' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
361 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '719' 1 0 ms
362 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '62' 1 0 ms
363 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/62' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
364 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '62' 1 0 ms
365 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '178' 1 0 ms
366 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/178' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
367 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '178' 1 0 ms
368 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '61' 1 0 ms
369 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/61' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
370 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '61' 1 0 ms
371 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '728' 1 0 ms
372 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/728' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
373 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '728' 1 0.01 ms
374 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '725' 1 0 ms
375 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/725' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
376 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '725' 1 0 ms
377 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '705' 1 0 ms
378 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/705' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
379 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '705' 1 0 ms
380 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '252' 1 0 ms
381 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/252' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
382 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '252' 1 0.01 ms
383 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '60' 1 0.01 ms
384 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/60' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
385 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '60' 1 0 ms
386 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '412' 1 0 ms
387 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/412' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
388 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '412' 1 0 ms
389 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '460' 1 0 ms
390 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/460' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
391 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '460' 1 0 ms
392 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '242' 1 0 ms
393 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/242' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
394 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '242' 1 0 ms
395 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '180' 1 0 ms
396 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/180' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
397 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '180' 1 0 ms
398 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '706' 1 0 ms
399 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/706' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
400 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '706' 1 0 ms
401 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '142' 1 0 ms
402 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/142' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
403 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '142' 1 0 ms
404 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/142' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
405 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '142' ORDER BY `category_name` ASC 11 0 ms
406 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '306' 1 0 ms
407 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/306' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
408 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '306' 1 0 ms
409 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '246' 1 0.01 ms
410 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/246' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
411 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '246' 1 0 ms
412 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '325' 1 0 ms
413 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/325' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
414 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '325' 1 0 ms
415 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '302' 1 0 ms
416 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/302' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
417 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '302' 1 0 ms
418 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '237' 1 0.01 ms
419 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/237' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
420 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '237' 1 0 ms
421 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '254' 1 0 ms
422 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/254' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
423 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '254' 1 0 ms
424 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '232' 1 0 ms
425 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/232' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
426 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '232' 1 0 ms
427 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '241' 1 0 ms
428 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/241' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
429 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '241' 1 0 ms
430 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '236' 1 0 ms
431 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/236' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
432 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '236' 1 0 ms
433 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '301' 1 0 ms
434 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/301' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
435 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '301' 1 0 ms
436 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '300' 1 0 ms
437 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/300' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
438 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '300' 1 0 ms
439 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '12' 1 0 ms
440 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/12' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
441 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '12' 1 0 ms
442 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/12' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
443 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '12' ORDER BY `category_name` ASC 13 0 ms
444 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '133' 1 0.01 ms
445 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/133' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
446 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '133' 1 0 ms
447 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '66' 1 0 ms
448 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/66' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
449 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '66' 1 0 ms
450 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '259' 1 0 ms
451 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/259' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
452 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '259' 1 0 ms
453 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '163' 1 0 ms
454 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/163' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
455 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '163' 1 0 ms
456 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '130' 1 0 ms
457 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/130' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
458 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '130' 1 0.02 ms
459 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '65' 1 0 ms
460 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/65' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
461 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '65' 1 0.01 ms
462 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '120' 1 0.01 ms
463 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/120' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
464 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '120' 1 0 ms
465 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '164' 1 0.01 ms
466 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/164' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.02 ms
467 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '164' 1 0 ms
468 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '131' 1 0 ms
469 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/131' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
470 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '131' 1 0.01 ms
471 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '129' 1 0 ms
472 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/129' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
473 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '129' 1 0.01 ms
474 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '128' 1 0 ms
475 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/128' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
476 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '128' 1 0 ms
477 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '165' 1 0 ms
478 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/165' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
479 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '165' 1 0 ms
480 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '64' 1 0 ms
481 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/64' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
482 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '64' 1 0 ms
483 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '13' 1 0.01 ms
484 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/13' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
485 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '13' 1 0.01 ms
486 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/13' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
487 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '13' ORDER BY `category_name` ASC 14 0 ms
488 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '168' 1 0 ms
489 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/168' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
490 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '168' 1 0 ms
491 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '352' 1 0 ms
492 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/352' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
493 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '352' 1 0.02 ms
494 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '307' 1 0 ms
495 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/307' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
496 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '307' 1 0.01 ms
497 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '67' 1 0 ms
498 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/67' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
499 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '67' 1 0 ms
500 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '167' 1 0 ms
501 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/167' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
502 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '167' 1 0 ms
503 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '303' 1 0 ms
504 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/303' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
505 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '303' 1 0 ms
506 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '249' 1 0 ms
507 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/249' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
508 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '249' 1 0 ms
509 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '330' 1 0.01 ms
510 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/330' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
511 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '330' 1 0 ms
512 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '68' 1 0 ms
513 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/68' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
514 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '68' 1 0 ms
515 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '630' 1 0 ms
516 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/630' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
517 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '630' 1 0 ms
518 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '631' 1 0 ms
519 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/631' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
520 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '631' 1 0 ms
521 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '309' 1 0.01 ms
522 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/309' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
523 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '309' 1 0 ms
524 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '231' 1 0 ms
525 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/231' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
526 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '231' 1 0 ms
527 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '296' 1 0 ms
528 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/296' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
529 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '296' 1 0 ms
530 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '604' 1 0 ms
531 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/604' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
532 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '604' 1 0 ms
533 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/604' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
534 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '604' ORDER BY `category_name` ASC 5 0.01 ms
535 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '606' 1 0 ms
536 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/606' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
537 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '606' 1 0 ms
538 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '632' 1 0 ms
539 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/632' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
540 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '632' 1 0 ms
541 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '605' 1 0 ms
542 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/605' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
543 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '605' 1 0 ms
544 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '607' 1 0.01 ms
545 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/607' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
546 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '607' 1 0 ms
547 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '710' 1 0.01 ms
548 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/710' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
549 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '710' 1 0.01 ms
550 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '14' 1 0.03 ms
551 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/14' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.02 ms
552 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '14' 1 0 ms
553 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/14' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
554 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '14' ORDER BY `category_name` ASC 9 0 ms
555 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '602' 1 0 ms
556 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/602' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
557 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '602' 1 0.01 ms
558 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '378' 1 0 ms
559 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/378' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
560 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '378' 1 0 ms
561 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '132' 1 0 ms
562 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/132' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
563 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '132' 1 0 ms
564 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '72' 1 0 ms
565 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/72' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
566 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '72' 1 0 ms
567 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '70' 1 0 ms
568 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/70' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
569 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '70' 1 0 ms
570 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '121' 1 0 ms
571 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/121' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
572 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '121' 1 0 ms
573 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '73' 1 0 ms
574 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/73' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
575 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '73' 1 0 ms
576 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '601' 1 0 ms
577 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/601' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
578 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '601' 1 0 ms
579 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '71' 1 0 ms
580 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/71' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
581 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '71' 1 0 ms
582 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '407' 1 0.01 ms
583 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/407' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
584 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '407' 1 0 ms
585 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/407' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
586 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '407' ORDER BY `category_name` ASC 1 0 ms
587 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '447' 1 0 ms
588 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/447' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
589 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '447' 1 0 ms
590 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '16' 1 0 ms
591 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/16' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
592 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '16' 1 0 ms
593 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/16' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
594 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '16' ORDER BY `category_name` ASC 14 0 ms
595 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '297' 1 0 ms
596 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/297' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
597 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '297' 1 0 ms
598 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '389' 1 0 ms
599 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/389' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
600 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '389' 1 0 ms
601 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '81' 1 0.01 ms
602 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/81' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
603 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '81' 1 0 ms
604 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '79' 1 0 ms
605 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/79' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
606 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '79' 1 0 ms
607 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '80' 1 0 ms
608 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/80' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
609 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '80' 1 0 ms
610 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '267' 1 0 ms
611 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/267' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
612 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '267' 1 0.01 ms
613 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '298' 1 0 ms
614 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/298' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
615 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '298' 1 0 ms
616 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '83' 1 0 ms
617 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/83' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
618 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '83' 1 0.01 ms
619 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '417' 1 0 ms
620 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/417' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
621 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '417' 1 0.01 ms
622 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '77' 1 0 ms
623 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/77' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
624 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '77' 1 0 ms
625 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '76' 1 0 ms
626 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/76' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
627 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '76' 1 0 ms
628 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '78' 1 0 ms
629 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/78' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
630 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '78' 1 0 ms
631 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '82' 1 0 ms
632 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/82' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
633 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '82' 1 0 ms
634 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '396' 1 0 ms
635 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/396' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
636 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '396' 1 0 ms
637 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '15' 1 0.01 ms
638 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/15' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
639 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '15' 1 0 ms
640 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/15' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
641 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '15' ORDER BY `category_name` ASC 2 0.01 ms
642 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '74' 1 0 ms
643 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/74' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
644 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '74' 1 0 ms
645 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '75' 1 0.01 ms
646 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/75' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
647 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '75' 1 0 ms
648 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '233' 1 0 ms
649 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/233' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
650 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '233' 1 0 ms
651 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '153' 1 0 ms
652 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/153' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
653 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '153' 1 0 ms
654 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '17' 1 0 ms
655 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/17' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
656 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '17' 1 0 ms
657 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/17' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
658 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '17' ORDER BY `category_name` ASC 2 0.01 ms
659 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '85' 1 0.01 ms
660 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/85' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
661 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '85' 1 0 ms
662 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '88' 1 0 ms
663 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/88' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
664 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '88' 1 0 ms
665 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '21' 1 0 ms
666 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/21' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
667 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '21' 1 0 ms
668 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/21' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
669 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '21' ORDER BY `category_name` ASC 6 0 ms
670 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '98' 1 0 ms
671 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/98' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
672 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '98' 1 0.01 ms
673 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '96' 1 0.01 ms
674 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/96' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
675 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '96' 1 0 ms
676 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '146' 1 0.01 ms
677 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/146' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
678 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '146' 1 0 ms
679 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '101' 1 0 ms
680 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/101' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
681 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '101' 1 0 ms
682 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '100' 1 0 ms
683 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/100' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
684 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '100' 1 0 ms
685 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '97' 1 0 ms
686 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/97' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
687 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '97' 1 0 ms
688 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '152' 1 0 ms
689 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/152' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
690 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '152' 1 0 ms
691 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/152' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
692 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '152' ORDER BY `category_name` ASC 3 0 ms
693 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '387' 1 0 ms
694 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/387' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
695 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '387' 1 0 ms
696 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '245' 1 0 ms
697 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/245' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
698 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '245' 1 0 ms
699 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '388' 1 0 ms
700 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/388' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
701 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '388' 1 0.01 ms
702 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '19' 1 0.01 ms
703 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/19' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
704 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '19' 1 0 ms
705 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/19' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
706 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '19' ORDER BY `category_name` ASC 4 0 ms
707 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '124' 1 0.01 ms
708 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/124' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
709 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '124' 1 0 ms
710 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '127' 1 0.01 ms
711 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/127' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
712 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '127' 1 0.01 ms
713 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '126' 1 0 ms
714 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/126' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
715 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '126' 1 0 ms
716 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '125' 1 0 ms
717 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/125' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
718 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '125' 1 0.02 ms
719 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '18' 1 0 ms
720 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/18' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
721 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '18' 1 0 ms
722 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/18' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
723 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '18' ORDER BY `category_name` ASC 7 0 ms
724 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '89' 1 0 ms
725 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/89' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
726 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '89' 1 0 ms
727 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '91' 1 0 ms
728 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/91' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
729 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '91' 1 0 ms
730 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '90' 1 0 ms
731 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/90' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
732 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '90' 1 0.01 ms
733 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '709' 1 0.01 ms
734 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/709' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
735 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '709' 1 0 ms
736 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '707' 1 0.01 ms
737 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/707' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
738 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '707' 1 0 ms
739 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '724' 1 0.02 ms
740 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/724' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
741 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '724' 1 0 ms
742 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '92' 1 0 ms
743 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/92' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
744 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '92' 1 0.01 ms
745 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '713' 1 0 ms
746 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/713' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
747 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '713' 1 0 ms
748 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '713' ORDER BY `category_name` ASC 2 0.01 ms
749 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '715' 1 0 ms
750 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/715' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
751 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '715' 1 0 ms
752 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '714' 1 0 ms
753 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/714' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
754 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '714' 1 0 ms
755 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '23' 1 0 ms
756 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/23' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
757 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '23' 1 0 ms
758 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/products_discount/23' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
759 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '23' ORDER BY `category_name` ASC 4 0.01 ms
760 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '114' 1 0 ms
761 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/114' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
762 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '114' 1 0.01 ms
763 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '113' 1 0 ms
764 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/113' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
765 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '113' 1 0 ms
766 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '716' 1 0 ms
767 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/716' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
768 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '716' 1 0 ms
769 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '708' 1 0 ms
770 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/708' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
771 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '1' AND `parent` = '708' 1 0 ms
772 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
773 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '0' 1 0 ms
774 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '0' ORDER BY `category_name` ASC 39 0.01 ms
775 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '637' 1 0 ms
776 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/637' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
777 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '637' 1 0 ms
778 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '637' ORDER BY `category_name` ASC 3 0 ms
779 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '649' 1 0 ms
780 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/649' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
781 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '649' 1 0 ms
782 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '652' 1 0 ms
783 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/652' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
784 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '652' 1 0 ms
785 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '650' 1 0 ms
786 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/650' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
787 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '650' 1 0 ms
788 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '938' 1 0 ms
789 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/938' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
790 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '938' 1 0 ms
791 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '702' 1 0 ms
792 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/702' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
793 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '702' 1 0 ms
794 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '702' ORDER BY `category_name` ASC 2 0 ms
795 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '703' 1 0.01 ms
796 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/703' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
797 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '703' 1 0 ms
798 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '704' 1 0 ms
799 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/704' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
800 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '704' 1 0 ms
801 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '638' 1 0 ms
802 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/638' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
803 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '638' 1 0 ms
804 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '638' ORDER BY `category_name` ASC 6 0 ms
805 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '919' 1 0 ms
806 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/919' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
807 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '919' 1 0 ms
808 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '653' 1 0 ms
809 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/653' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
810 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '653' 1 0 ms
811 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '651' 1 0 ms
812 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/651' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
813 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '651' 1 0 ms
814 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '654' 1 0 ms
815 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/654' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
816 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '654' 1 0 ms
817 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '916' 1 0 ms
818 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/916' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
819 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '916' 1 0 ms
820 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '915' 1 0 ms
821 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/915' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
822 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '915' 1 0.01 ms
823 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '648' 1 0 ms
824 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/648' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
825 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '648' 1 0 ms
826 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '648' ORDER BY `category_name` ASC 3 0 ms
827 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '655' 1 0 ms
828 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/655' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
829 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '655' 1 0 ms
830 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '656' 1 0 ms
831 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/656' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
832 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '656' 1 0 ms
833 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '657' 1 0.01 ms
834 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/657' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
835 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '657' 1 0 ms
836 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '641' 1 0 ms
837 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/641' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
838 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '641' 1 0 ms
839 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '641' ORDER BY `category_name` ASC 3 0 ms
840 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '659' 1 0 ms
841 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/659' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
842 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '659' 1 0 ms
843 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '660' 1 0 ms
844 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/660' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
845 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '660' 1 0 ms
846 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '658' 1 0 ms
847 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/658' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
848 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '658' 1 0 ms
849 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '903' 1 0.01 ms
850 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/903' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
851 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '903' 1 0 ms
852 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '903' ORDER BY `category_name` ASC 1 0 ms
853 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '926' 1 0 ms
854 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/926' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
855 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '926' 1 0 ms
856 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '647' 1 0.01 ms
857 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/647' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
858 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '647' 1 0 ms
859 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '647' ORDER BY `category_name` ASC 3 0 ms
860 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '663' 1 0 ms
861 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/663' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
862 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '663' 1 0 ms
863 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '662' 1 0 ms
864 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/662' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
865 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '662' 1 0 ms
866 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '664' 1 0 ms
867 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/664' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
868 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '664' 1 0 ms
869 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '902' 1 0 ms
870 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/902' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
871 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '902' 1 0.01 ms
872 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '902' ORDER BY `category_name` ASC 2 0 ms
873 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '921' 1 0 ms
874 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/921' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
875 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '921' 1 0 ms
876 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '922' 1 0 ms
877 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/922' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
878 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '922' 1 0 ms
879 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '640' 1 0 ms
880 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/640' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
881 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '640' 1 0 ms
882 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '640' ORDER BY `category_name` ASC 5 0.01 ms
883 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '667' 1 0 ms
884 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/667' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
885 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '667' 1 0 ms
886 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '884' 1 0 ms
887 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/884' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
888 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '884' 1 0 ms
889 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '666' 1 0 ms
890 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/666' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
891 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '666' 1 0 ms
892 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '665' 1 0.05 ms
893 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/665' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
894 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '665' 1 0 ms
895 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '917' 1 0 ms
896 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/917' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
897 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '917' 1 0 ms
898 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '673' 1 0 ms
899 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/673' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
900 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '673' 1 0 ms
901 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '673' ORDER BY `category_name` ASC 7 0.01 ms
902 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '677' 1 0 ms
903 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/677' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
904 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '677' 1 0 ms
905 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '680' 1 0 ms
906 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/680' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
907 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '680' 1 0 ms
908 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '676' 1 0 ms
909 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/676' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
910 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '676' 1 0 ms
911 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '674' 1 0 ms
912 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/674' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
913 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '674' 1 0.01 ms
914 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '675' 1 0 ms
915 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/675' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
916 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '675' 1 0 ms
917 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '923' 1 0 ms
918 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/923' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
919 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '923' 1 0 ms
920 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '678' 1 0 ms
921 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/678' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
922 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '678' 1 0 ms
923 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '965' 1 0 ms
924 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/965' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
925 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '965' 1 0 ms
926 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '967' 1 0 ms
927 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/967' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
928 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '967' 1 0 ms
929 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '969' 1 0 ms
930 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/969' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
931 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '969' 1 0 ms
932 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '966' 1 0 ms
933 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/966' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
934 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '966' 1 0 ms
935 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '968' 1 0 ms
936 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/968' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
937 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '968' 1 0 ms
938 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '970' 1 0 ms
939 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/970' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
940 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '970' 1 0 ms
941 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '971' 1 0 ms
942 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/971' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
943 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '971' 1 0 ms
944 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '972' 1 0 ms
945 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/972' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
946 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '972' 1 0 ms
947 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '973' 1 0 ms
948 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/973' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
949 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '973' 1 0 ms
950 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '974' 1 0 ms
951 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/974' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
952 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '974' 1 0.01 ms
953 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '975' 1 0 ms
954 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/975' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
955 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '975' 1 0 ms
956 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '693' 1 0 ms
957 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/693' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
958 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '693' 1 0 ms
959 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '693' ORDER BY `category_name` ASC 2 0 ms
960 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '695' 1 0 ms
961 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/695' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
962 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '695' 1 0.01 ms
963 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '694' 1 0 ms
964 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/694' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
965 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '694' 1 0 ms
966 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '936' 1 0.01 ms
967 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/936' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
968 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '936' 1 0 ms
969 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '698' 1 0 ms
970 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/698' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
971 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '698' 1 0 ms
972 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '698' ORDER BY `category_name` ASC 1 0 ms
973 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '701' 1 0 ms
974 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/701' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
975 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '701' 1 0 ms
976 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '642' 1 0 ms
977 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/642' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
978 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '642' 1 0 ms
979 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '642' ORDER BY `category_name` ASC 5 0 ms
980 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '671' 1 0 ms
981 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/671' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
982 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '671' 1 0 ms
983 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '670' 1 0 ms
984 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/670' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
985 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '670' 1 0 ms
986 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '669' 1 0 ms
987 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/669' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
988 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '669' 1 0.01 ms
989 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '668' 1 0.02 ms
990 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/668' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
991 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '668' 1 0.1 ms
992 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '672' 1 0 ms
993 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/672' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
994 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '672' 1 0 ms
995 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '944' 1 0 ms
996 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/944' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
997 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '944' 1 0 ms
998 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '681' 1 0 ms
999 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/681' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1000 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '681' 1 0 ms
1001 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '681' ORDER BY `category_name` ASC 5 0 ms
1002 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '683' 1 0 ms
1003 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/683' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1004 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '683' 1 0 ms
1005 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '682' 1 0 ms
1006 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/682' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1007 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '682' 1 0 ms
1008 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '684' 1 0 ms
1009 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/684' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1010 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '684' 1 0 ms
1011 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '883' 1 0 ms
1012 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/883' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1013 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '883' 1 0 ms
1014 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '901' 1 0 ms
1015 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/901' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1016 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '901' 1 0 ms
1017 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '952' 1 0 ms
1018 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/952' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1019 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '952' 1 0 ms
1020 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '720' 1 0 ms
1021 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/720' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1022 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '720' 1 0 ms
1023 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '720' ORDER BY `category_name` ASC 3 0 ms
1024 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '900' 1 0 ms
1025 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/900' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1026 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '900' 1 0 ms
1027 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '882' 1 0 ms
1028 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/882' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1029 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '882' 1 0 ms
1030 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '722' 1 0 ms
1031 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/722' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1032 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '722' 1 0 ms
1033 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '943' 1 0 ms
1034 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/943' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1035 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '943' 1 0 ms
1036 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '906' 1 0 ms
1037 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/906' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1038 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '906' 1 0 ms
1039 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '906' ORDER BY `category_name` ASC 5 0.01 ms
1040 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '928' 1 0 ms
1041 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/928' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1042 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '928' 1 0.01 ms
1043 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '929' 1 0 ms
1044 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/929' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1045 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '929' 1 0 ms
1046 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '930' 1 0 ms
1047 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/930' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1048 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '930' 1 0 ms
1049 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '927' 1 0 ms
1050 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/927' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1051 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '927' 1 0 ms
1052 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '931' 1 0 ms
1053 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/931' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1054 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '931' 1 0 ms
1055 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '696' 1 0 ms
1056 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/696' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1057 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '696' 1 0 ms
1058 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '696' ORDER BY `category_name` ASC 3 0 ms
1059 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '697' 1 0 ms
1060 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/697' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1061 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '697' 1 0 ms
1062 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '723' 1 0 ms
1063 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/723' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1064 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '723' 1 0 ms
1065 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '933' 1 0 ms
1066 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/933' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1067 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '933' 1 0 ms
1068 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '646' 1 0 ms
1069 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/646' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1070 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '646' 1 0 ms
1071 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '646' ORDER BY `category_name` ASC 4 0.01 ms
1072 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '679' 1 0.01 ms
1073 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/679' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1074 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '679' 1 0 ms
1075 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '899' 1 0.01 ms
1076 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/899' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1077 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '899' 1 0 ms
1078 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '685' 1 0 ms
1079 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/685' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1080 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '685' 1 0 ms
1081 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '924' 1 0.01 ms
1082 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/924' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1083 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '924' 1 0 ms
1084 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '643' 1 0 ms
1085 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/643' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1086 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '643' 1 0 ms
1087 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '643' ORDER BY `category_name` ASC 4 0 ms
1088 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '686' 1 0 ms
1089 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/686' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1090 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '686' 1 0.01 ms
1091 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '687' 1 0 ms
1092 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/687' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1093 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '687' 1 0.01 ms
1094 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '688' 1 0 ms
1095 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/688' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1096 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '688' 1 0 ms
1097 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '918' 1 0 ms
1098 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/918' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1099 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '918' 1 0 ms
1100 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '905' 1 0 ms
1101 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/905' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1102 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '905' 1 0 ms
1103 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '905' ORDER BY `category_name` ASC 2 0 ms
1104 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '935' 1 0 ms
1105 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/935' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1106 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '935' 1 0 ms
1107 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '934' 1 0.01 ms
1108 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/934' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1109 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '934' 1 0 ms
1110 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '907' 1 0 ms
1111 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/907' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1112 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '907' 1 0 ms
1113 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '907' ORDER BY `category_name` ASC 1 0 ms
1114 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '925' 1 0 ms
1115 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/925' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1116 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '925' 1 0 ms
1117 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '937' 1 0 ms
1118 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/937' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1119 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '937' 1 0 ms
1120 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '644' 1 0 ms
1121 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/644' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1122 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '644' 1 0 ms
1123 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '644' ORDER BY `category_name` ASC 2 0 ms
1124 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '689' 1 0 ms
1125 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/689' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1126 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '689' 1 0 ms
1127 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '700' 1 0 ms
1128 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/700' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1129 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '11' AND `parent` = '700' 1 0 ms
1130 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/7' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1131 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '0' 1 0 ms
1132 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '0' ORDER BY `category_name` ASC 2 0 ms
1133 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '618' 1 0 ms
1134 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/618' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1135 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '618' 1 0 ms
1136 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '618' ORDER BY `category_name` ASC 11 0 ms
1137 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '619' 1 0 ms
1138 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/619' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1139 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '619' 1 0 ms
1140 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '620' 1 0 ms
1141 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/620' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1142 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '620' 1 0 ms
1143 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '621' 1 0 ms
1144 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/621' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1145 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '621' 1 0 ms
1146 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '622' 1 0 ms
1147 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/622' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1148 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '622' 1 0 ms
1149 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '623' 1 0 ms
1150 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/623' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1151 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '623' 1 0 ms
1152 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '624' 1 0 ms
1153 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/624' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1154 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '624' 1 0 ms
1155 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '625' 1 0 ms
1156 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/625' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1157 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '625' 1 0 ms
1158 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '626' 1 0 ms
1159 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/626' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1160 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '626' 1 0 ms
1161 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '627' 1 0 ms
1162 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/627' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1163 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '627' 1 0.01 ms
1164 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '628' 1 0 ms
1165 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/628' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1166 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '628' 1 0.01 ms
1167 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '951' 1 0 ms
1168 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/951' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1169 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '951' 1 0 ms
1170 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '584' 1 0.01 ms
1171 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/584' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1172 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '584' 1 0 ms
1173 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '584' ORDER BY `category_name` ASC 20 0.01 ms
1174 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '511' 1 0 ms
1175 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/511' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1176 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '511' 1 0 ms
1177 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '512' 1 0 ms
1178 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/512' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1179 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '512' 1 0 ms
1180 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '513' 1 0 ms
1181 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/513' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1182 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '513' 1 0 ms
1183 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '514' 1 0 ms
1184 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/514' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1185 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '514' 1 0 ms
1186 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '515' 1 0 ms
1187 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/515' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1188 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '515' 1 0 ms
1189 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '516' 1 0 ms
1190 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/516' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1191 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '516' 1 0 ms
1192 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '517' 1 0 ms
1193 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/517' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1194 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '517' 1 0 ms
1195 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '518' 1 0 ms
1196 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/518' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1197 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '518' 1 0 ms
1198 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '519' 1 0 ms
1199 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/519' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1200 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '519' 1 0 ms
1201 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '520' 1 0 ms
1202 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/520' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1203 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '520' 1 0 ms
1204 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '521' 1 0 ms
1205 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/521' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1206 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '521' 1 0 ms
1207 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '522' 1 0 ms
1208 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/522' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1209 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '522' 1 0 ms
1210 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '523' 1 0 ms
1211 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/523' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1212 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '523' 1 0 ms
1213 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '524' 1 0 ms
1214 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/524' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1215 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '524' 1 0 ms
1216 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '525' 1 0 ms
1217 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/525' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1218 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '525' 1 0 ms
1219 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '526' 1 0 ms
1220 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/526' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1221 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '526' 1 0 ms
1222 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '527' 1 0 ms
1223 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/527' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1224 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '527' 1 0 ms
1225 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '528' 1 0 ms
1226 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/528' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1227 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '528' 1 0 ms
1228 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '529' 1 0 ms
1229 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/529' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1230 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '529' 1 0.01 ms
1231 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '950' 1 0.01 ms
1232 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/950' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1233 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '7' AND `parent` = '950' 1 0.02 ms
1234 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/4' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1235 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '0' 1 0 ms
1236 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '0' ORDER BY `category_name` ASC 6 0 ms
1237 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '889' 1 0 ms
1238 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/889' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1239 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '889' 1 0 ms
1240 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '889' ORDER BY `category_name` ASC 9 0 ms
1241 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '890' 1 0 ms
1242 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/890' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1243 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '890' 1 0 ms
1244 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '891' 1 0.01 ms
1245 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/891' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1246 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '891' 1 0 ms
1247 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '893' 1 0 ms
1248 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/893' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1249 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '893' 1 0 ms
1250 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '892' 1 0.01 ms
1251 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/892' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1252 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '892' 1 0 ms
1253 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '896' 1 0 ms
1254 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/896' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1255 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '896' 1 0 ms
1256 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '894' 1 0.01 ms
1257 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/894' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.03 ms
1258 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '894' 1 0 ms
1259 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '898' 1 0 ms
1260 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/898' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1261 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '898' 1 0 ms
1262 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '895' 1 0 ms
1263 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/895' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1264 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '895' 1 0 ms
1265 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '897' 1 0 ms
1266 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/897' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1267 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '897' 1 0 ms
1268 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '444' 1 0 ms
1269 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/444' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1270 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '444' 1 0 ms
1271 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '444' ORDER BY `category_name` ASC 1 0.01 ms
1272 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '911' 1 0 ms
1273 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/911' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1274 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '911' 1 0 ms
1275 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '947' 1 0 ms
1276 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/947' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1277 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '947' 1 0 ms
1278 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '947' ORDER BY `category_name` ASC 1 0 ms
1279 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '949' 1 0 ms
1280 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/949' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1281 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '949' 1 0 ms
1282 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '611' 1 0 ms
1283 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/611' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1284 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '611' 1 0 ms
1285 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '611' ORDER BY `category_name` ASC 5 0 ms
1286 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '613' 1 0.01 ms
1287 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/613' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1288 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '613' 1 0 ms
1289 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '614' 1 0 ms
1290 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/614' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1291 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '614' 1 0 ms
1292 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '615' 1 0 ms
1293 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/615' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1294 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '615' 1 0.01 ms
1295 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '617' 1 0 ms
1296 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/617' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1297 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '617' 1 0.01 ms
1298 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '616' 1 0 ms
1299 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/616' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1300 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '616' 1 0 ms
1301 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '446' 1 0 ms
1302 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/446' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1303 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '446' 1 0 ms
1304 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '908' 1 0 ms
1305 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/908' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1306 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '908' 1 0.01 ms
1307 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '908' ORDER BY `category_name` ASC 1 0 ms
1308 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '910' 1 0 ms
1309 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/910' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1310 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '4' AND `parent` = '910' 1 0 ms
1311 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/9' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1312 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '9' AND `parent` = '0' 1 0 ms
1313 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/6' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1314 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '0' 1 0 ms
1315 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '0' ORDER BY `category_name` ASC 15 0 ms
1316 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '497' 1 0.01 ms
1317 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/497' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1318 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '497' 1 0 ms
1319 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '498' 1 0.01 ms
1320 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/498' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1321 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '498' 1 0 ms
1322 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '499' 1 0.01 ms
1323 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/499' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1324 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '499' 1 0 ms
1325 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '500' 1 0.01 ms
1326 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/500' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1327 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '500' 1 0 ms
1328 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '501' 1 0.01 ms
1329 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/501' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1330 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '501' 1 0.01 ms
1331 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '502' 1 0 ms
1332 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/502' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1333 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '502' 1 0 ms
1334 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '503' 1 0 ms
1335 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/503' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1336 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '503' 1 0 ms
1337 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '504' 1 0.01 ms
1338 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/504' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1339 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '504' 1 0 ms
1340 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '505' 1 0 ms
1341 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/505' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1342 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '505' 1 0.01 ms
1343 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '506' 1 0 ms
1344 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/506' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1345 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '506' 1 0 ms
1346 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '507' 1 0 ms
1347 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/507' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1348 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '507' 1 0.01 ms
1349 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '608' 1 0 ms
1350 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/608' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1351 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '608' 1 0 ms
1352 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '508' 1 0 ms
1353 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/508' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1354 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '508' 1 0 ms
1355 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '509' 1 0 ms
1356 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/509' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1357 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '509' 1 0 ms
1358 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '510' 1 0 ms
1359 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/510' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1360 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '6' AND `parent` = '510' 1 0 ms
1361 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/13' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1362 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '0' 1 0 ms
1363 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '0' ORDER BY `category_name` ASC 1 0 ms
1364 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '945' 1 0 ms
1365 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_landing/945' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1366 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '945' 1 0 ms
1367 SELECT `id` as `Category.Id`, `product_type` as `Category.Product_type`, `category_name` as `Category.Category_name`, `parent` as `Category.Parent` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '945' ORDER BY `category_name` ASC 1 0 ms
1368 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '948' 1 0 ms
1369 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_category/948' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1370 SELECT COUNT(*) AS `Category.Findcount` FROM `product_categories` AS `Category` WHERE `product_type` = '13' AND `parent` = '948' 1 0 ms
1371 SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language`, `route_old` as `Route.Route_old` FROM `routes` AS `Route` WHERE `url` = '/wanddecoratie-zoeken/Let%20It%20Snow/479' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 0 0 ms
1372 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/ingelijste-kunst' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1373 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/pod' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1374 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/veilig-en-betrouwbaar' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1375 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/contact' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1376 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/search/simple' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1377 SELECT `` as `ArtistBiography.` FROM `artist_biographies` AS `ArtistBiography` WHERE LENGTH(`artist_first`) > 0 AND LENGTH(`artist_last`) > 0 AND `language` = '1' ORDER BY `artist_last`, `artist_first`
1378 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/contact' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1379 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/contact' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1380 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/customupload' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1381 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/1' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1382 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/7' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1383 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/4' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1384 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/static_frames' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1385 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/artists/index' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1386 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/11' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1387 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/product_type/6' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1388 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/customupload' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1389 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/giftcards' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1390 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/over-ons' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1391 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/in-de-media' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1392 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/assortiment' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0.01 ms
1393 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/contact' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1394 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/veelgestelde-vragen' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1395 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/bestellen-verzenden-retourneren' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1396 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/retour' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1397 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/betaling' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1398 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/aanleverspecificaties' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1399 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/bedrijven' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1400 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/onze-klanten' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1401 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/algemene-voorwaarden' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms
1402 SELECT `route` as `Route.Route` FROM `routes` AS `Route` WHERE `url` = '/page/showpage/privacy-policy' AND `language` = '1' ORDER BY `route` DESC LIMIT 1 1 0 ms

Page execution time: 2.166 seconds, of which 20.09 ms queries.